--例3：使用游标实现加薪操作
	select * from People
	declare increase cursor scroll
	for select peopleid from People
	open increase
	declare @gz money=1000,@iid int
	fetch first from increase into @iid
		while(@@FETCH_STATUS=0)
			begin update People set PeopleSalary+=@gz where PeopleId=@iid
			fetch next from increase into @iid
		end
	close increase
--例4:使用游标删除不达标员工
	declare dele cursor scroll
	for select PeopleId from people
	open dele
	declare @did int
	fetch first from dele into @did
	while (@@FETCH_STATUS=0)
		begin
		delete from People where PeopleSalary>1000000
		fetch next from dele into @did
		end
	close dele

--2.使用游标 实现:如果A表与B表中ID字段值相同，那么将B表中的省份，城市 修改成与A表中的城市一致（连表）
	declare aupdate cursor scroll
	for select id,province,city  from a
	open aupdate
	declare @aid int,@aprovince varchar(50),@acity varchar(50)
	fetch first from eupdate into @eid,@eprovince,@ecity
	while (@@FETCH_STATUS=0)
	begin
			update B set B.Province = @aprovince , B.City = @acity where B.id = @aid
			fetch next from aupdate into @aid,@aProvince,@aCity
	end
	close aupdate